package cn.edu.sziit.web;

import java.io.IOException;
import java.sql.Connection;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.edu.sziit.dao.GradeDao;
import cn.edu.sziit.model.Grade;
import cn.edu.sziit.model.PageBean;
import cn.edu.sziit.util.DbUtil;
import cn.edu.sziit.util.JsonUtil;
import cn.edu.sziit.util.ResponseUtil;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

public class GradeComboListServlet extends HttpServlet{
	DbUtil dbUtil=new DbUtil();
	GradeDao gradeDao=new GradeDao();

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	   this.doPost(request, response);
	   
	}

	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		
        Connection con=null;
        try{
        	/*con =dbUtil.getCon();
        	JSONArray jsonArray=new JSONArray();
        	JSONObject jsonObject=new JSONObject();
        	jsonObject.put("id", " ");
        	jsonObject.put("gradeName", "请选择...");
        	jsonArray.add(jsonObject);
        	jsonArray.addAll(JsonUtil.formatRsToJsonArray(gradeDao.gradeList(con, null,null)));
        	
    
            ResponseUtil.write(response, jsonArray);*/
        	con=dbUtil.getCon();
			JSONArray jsonArray=new JSONArray();
			JSONObject jsonObject=new JSONObject();
			jsonObject.put("id", "");
			jsonObject.put("gradeName", "请选择...");
			jsonArray.add(jsonObject);
			jsonArray.addAll(JsonUtil.formatRsToJsonArray(gradeDao.gradeList(con, null,null)));
			ResponseUtil.write(response, jsonArray);
        }catch(Exception e){
        	e.printStackTrace();
        }finally{
        	try {
				dbUtil.closeCon(con);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
        }
	}
  
}
